# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月21日
"""
import openpyxl

myBook=openpyxl.load_workbook('员工表.xlsx',data_only=True)
mySheet=myBook.active

myList=list(map(lambda myCell:
                myCell.value.capitalize(),list(mySheet.columns)[3][1:]))
myIndex=0
for myCell in list(mySheet.columns)[3][1:]:
	myCell.value=myList[myIndex]
	myIndex+=1

myBook.save('结果表-员工表.xlsx')

